------------------------------------------------------------------------
Connected. Running post-cleanup verification.
------------------------------------------------------------------------
## Foreign Keys
CONSTRAINT_NAME	TABLE_NAME	COLUMN_NAME	REFERENCED_TABLE_NAME
fk_objects_room_v3	objects	location_id	rooms
fk_qc_char	quest_clues	character_id	characters
fk_qc_quest	quest_clues	quest_id	quests
fk_qs_quest	quest_steps	quest_id	quests
fk_se_dst_v3	special_exits	destination_room_id	rooms
fk_se_src_v3	special_exits	source_room_id	rooms
## Indexes: rooms
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
rooms	0	PRIMARY	1	id	A	0				BTREE			NO
rooms	0	short_id	1	short_id	A	0				BTREE			NO
rooms	0	uniq_room_coords_v3	1	x	A	0				BTREE			NO
rooms	0	uniq_room_coords_v3	2	y	A	0				BTREE			NO
rooms	0	uniq_room_coords_v3	3	z	A	0				BTREE			NO
## Indexes: objects
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
objects	0	PRIMARY	1	id	A	0				BTREE			NO
objects	1	idx_objects_short_loc_v3	1	short_id	A	0				BTREE			NO
objects	1	idx_objects_short_loc_v3	2	location_id	A	0			YES	BTREE			NO
objects	1	idx_objects_location_v3	1	location_id	A	0			YES	BTREE			NO
## Indexes: quests
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
quests	0	PRIMARY	1	id	A	3				BTREE			NO
quests	0	uniq_quests_code	1	code	A	3				BTREE			NO
## Indexes: special_exits
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
special_exits	0	PRIMARY	1	id	A	0				BTREE			NO
special_exits	1	idx_se_src_v3	1	source_room_id	A	0				BTREE			NO
special_exits	1	idx_se_dst_v3	1	destination_room_id	A	0				BTREE			NO
## Indexes: quest_steps
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
quest_steps	0	PRIMARY	1	id	A	9				BTREE			NO
quest_steps	0	uniq_qstep	1	quest_id	A	9			YES	BTREE			NO
quest_steps	0	uniq_qstep	2	step_number	A	9				BTREE			NO
quest_steps	1	idx_qs_qid	1	quest_id	A	9			YES	BTREE			NO
## Indexes: quest_clues
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
quest_clues	0	PRIMARY	1	id	A	3				BTREE			NO
quest_clues	1	idx_qc_char	1	character_id	A	3			YES	BTREE			NO
quest_clues	1	idx_qc_qid	1	quest_id	A	3			YES	BTREE			NO
------------------------------------------------------------------------
Verification complete.
------------------------------------------------------------------------